[dbo].[BAEImisUdFieldGetAllByTableName]

SQLServer > iMIS1521GA > Stored Procedures > dbo.BAEImisUdFieldGetAllByTableName

Properties
Parameters
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

Name	Data Type	Max Length (Bytes)
@TableName	varchar(30)	30

SQL Script

create procedure [dbo].[BAEImisUdFieldGetAllByTableName] @TableName as
varchar(30)
AS
    SELECT DISTINCT *
    FROM UD_Field udf, UD_WindowFields udwf
    WHERE udf.TABLE_NAME = @TableName AND udwf.TABLE_NAME = @TableName AND udf.FIELD_NAME = udwf.FIELD_NAME

GO

Uses

[dbo].[UD_Field]
[dbo].[UD_WindowFields]
dbo